array_in: '{}}'::text[]

Is there a reason the array_in parser accepts additional closing braces
at the end?

oocms=# SELECT '{}}'::text[];
text
------
{}
(1 запись)

Thanks

--
Markus Bertheau <twanger [at] bluetwanger.de>


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
twanger [ Mo, 23 August 2004 13:45 ] [ ID #453370 ]

Re: array_in: '{}}'::text[]

В Пнд, 23.08.2004, в 13:45, Markus Bertheau пишет:
> Is there a reason the array_in parser accepts additional closing braces
> at the end?

In fact it seems to accept everything after the closing brace matching
the first opening brace.

Thanks

--
Markus Bertheau <twanger [at] bluetwanger.de>


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
twanger [ Mo, 23 August 2004 13:50 ] [ ID #453371 ]

Re: array_in: '{}}'::text[]

Markus Bertheau wrote:
> Is there a reason the array_in parser accepts additional closing braces
> at the end?
>
> oocms=# SELECT '{}}'::text[];
> text
> ------
> {}
> (1 запись)

Hmmm, I was *about* to say that this is fixed in cvs (and indeed, the
array_in parser is significantly tightened up compared to previous
releases), but unfortunately, there is still work to be done :(

regression=# SELECT '{}}'::text[];
text
------
{}
(1 row)

regression=# select version();
version
------------------------------------------------------------ ---------------------------------------------------------
PostgreSQL 8.0.0beta1 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
(1 row)

Look for a fix soon, at a cvs repository near you....

Joe

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
mail [ Mo, 23 August 2004 20:32 ] [ ID #453375 ]
Datenbanken » comp.databases.postgresql.sql » array_in: '{}}'::text[]

Vorheriges Thema: reply to setting
Nächstes Thema: TSearch2 other languages